Unlimited Powerful Learning
PRESENTED BY : Shridhar
shridharkc93@gmail.co
m
Unlimited Powerful Learning
Installing Mysql on windows step by step :
Version Information :
•Mysql-8.1.0
Step 1 :
•Download the mysql community server from
MySQL official website.
•By clicking the above link you will see these
options
shown here.
•Select the version of mysql server and
operating
system .
•We will be using windows msi installer so click
on
the button besides windows (x86,64bit) MSI
installer.
INSTALLATION
Unlimited Powerful Learning
Step2 :
•Once you click on the download
option
you will be redirected to this page.
•You can login or sign up to your
account
and download the installer.
•In our case we will be skipping login
and
sign up by clicking on No thanks,
just
start my download.
Unlimited Powerful Learning
Step3 :
•Go to your download folder where you can see mysql installer, right click on it and click
install
to start the installation wizard.
Unlimited Powerful Learning
Step4 :
•MySQL server installation has
started.
•Remember to give necessary
permissions to start the
installation.
Unlimited Powerful Learning
Step5 :
•Read the license agreement and
and click I accept the terms in
the
license agreement and click next.
Unlimited Powerful Learning
Step6 :
•Choose setup type
•We will select Typical installation
and click on next.
Unlimited Powerful Learning
Step7 :
•Complete the mySQL server
setup
wizard by checking run MySQL
configurator and clicking finish.
Unlimited Powerful Learning
Step8 :
•We will be prompted with MySQL
configurator welcome page.
•To start MySQL configuration
click
next.
Unlimited Powerful Learning
Step9 :
•This window gives you different
type
of MySQL installation.
•Iam selecting development
computer
as Iam a developer so that I need
all
the products which help for my
development purposes.
•We will keep the connectivity to
the
default value. You can change it
according to your needs. And
click
next.
Unlimited Powerful Learning
Step10 :
•Here you can set your root
account
password
•If you wish to add new user
to the account, click on add
user
in MySQL user accounts
section.
and click next
Unlimited Powerful Learning
Step11 :
•Leave the windows services
to default and click next.
Unlimited Powerful Learning
Step12 :
•Keep the server file permissions
to
default and click next.
Unlimited Powerful Learning
Step13 :
•We will create sample world
database for testing, you can
delete
it later if you don’t need it.
Unlimited Powerful Learning
Step14 :
•Press Execute to apply
configurations
on the previous steps.
Unlimited Powerful Learning
Step15 :
•After execution, you can see
below
green colored ticks on every
config
option.
Unlimited Powerful Learning
Step16 :
•Click on finish and you got
your
MySQL server installed on
your
windows operating system.
Unlimited Powerful Learning
Testing :
•Search for MySQL in your
taskbar
search item, There you can
see all
MySQL products which
installed
•And click on MySQL command
line
client.
Unlimited Powerful Learning
Testing :
•After it will ask your MySQL
password to login, after login
you could see the MySQL
prompt
like shown here.
Unlimited Powerful Learning
Testing :
•MySQL comes along with
default
databases.
•we can see databases by using
show databases; command.